Best practices for shrinking files in SQL server

Right-clickthedatabaseandselectTasks->Shrink->Files.ChangethetypetoLog.UnderShrinkaction,selectReleaseunusedspaceandclickOK.,ThisarticledescribeshowtoshrinkadataorlogfileinSQLServerbyusingSQLServerManagementStudioorTransact-SQL.,您可以使用DBCCSHR...。參考影片的文章的如下：

Step-by-Step Guide: Reducing Log File Size in MS SQL Server 2022 using the Detach Option
Step-by-Step Guide: Reducing Log File Size in MS SQL Server 2022 using the Detach Option
Shrinking Your MS SQL Server Transaction Log File
Shrinking Your MS SQL Server Transaction Log File
2. Transaction log file is full- How to resolve?
2. Transaction log file is full- How to resolve?
【軟體資料庫DataBase】SQLServer Log shipping建置PART 1
【軟體資料庫DataBase】SQLServer Log shipping建置PART 1
How to Shrink Data and Log Files | SQL Server | Database Design
How to Shrink Data and Log Files | SQL Server | Database Design
How to Clear SQL Server Transaction Log to Regain Space
How to Clear SQL Server Transaction Log to Regain Space
How to Shrink TempDB Database in SQL Server
How to Shrink TempDB Database in SQL Server
Shrinking Your MS SQL Server Transaction Log File
Shrinking Your MS SQL Server Transaction Log File
How to Shrink Transaction Log SQL Server
How to Shrink Transaction Log SQL Server
Difference bw differential and Log backups || Ms SQL
Difference bw differential and Log backups || Ms SQL

參考內容推薦

Truncate and shrink log files in SQL Server

Right-click the database and select Tasks -> Shrink -> Files. Change the type to Log . Under Shrink action, select Release unused space and click OK.

Shrink a File - SQL Server

This article describes how to shrink a data or log file in SQL Server by using SQL Server Management Studio or Transact-SQL.

DBCC 收縮檔案（Transact-SQL） - SQL Server

您可以使用 DBCC SHRINKFILE <target_size> 縮減空白檔案的預設大小。 例如，如果建立5 MB 的檔案，然後再將檔案縮減為3 MB 且檔案仍維持空白，則預設的檔案 ...

SQL Server LDF 容量大爆炸(SQL Server ldf truncate & shrink)

Shrink Log file 縮小交易紀錄檔​ 多數時候資料庫管理者以及系統管理者，真正想要解決的是縮小交易紀錄檔，也就是令交易紀錄檔在檔案系統中所佔用的大小減少 ...

How to shrink a log file without backuping first?

You can temporarily set recovery model to simple and truncate log. You also need to find the long running transaction that is active and find the root cause.

Shrink Microsoft SQL Server Transaction Log Safely and Effectively

Right-click the database with Transaction Log that must shrink. Select Tasks > Shrink > Files. Click to shrink files. The interface that comes up gives options ...

How to Shrink a Microsoft SQL Server Database Transaction Log File

MS SQL Server Database Log files can grow large causing your database to go offline and be unavailable if the Transaction Log drive location ...

How to shrink the transaction log in SQL Server

On the Shrink File window, change the File Type to Log. You can also choose to either release unused space, reorganize pages before releasing ...

Microsoft SQL Admins: How can I reduce the size of my logs?

Database > Tasks > Shrink > Log files (I usually only show about 250MB of available shrink space anyway). Set database recovery type from Full ...

How to shrink the transaction log file in SQL Server

Expand Databases and then right-click the database that you want to shrink. Point to Tasks, point to Shrink and then click Files. Select the ...

mssqlshrinklogfile

Right-clickthedatabaseandselectTasks->Shrink->Files.ChangethetypetoLog.UnderShrinkaction,selectReleaseunusedspaceandclickOK.,ThisarticledescribeshowtoshrinkadataorlogfileinSQLServerbyusingSQLServerManagementStudioorTransact-SQL.,您可以使用DBCCSHRINKFILE縮減空白檔案的預設大小。例如，如果建立5MB的檔案，然後再將檔案縮減為3MB且檔案仍維持空白，則預設的檔案 ...,ShrinkLogfile...

參考資訊如下